SEATTLE DATA

Dataset statistics

Number of variables	46
Number of observations	3376
Missing cells	19952
Missing cells (%)	12.8%
Total size in memory	1.2 MiB
Average record size in memory	361.0 B

Variable types

Numeric	29
Text	15
Boolean	1
Unsupported	1

Alerts

`DataYear` has constant value "2016"	Constant
`City` has constant value "Seattle"	Constant
`State` has constant value "WA"	Constant
`DefaultData` is highly imbalanced (78.8%)	Imbalance
`SecondLargestPropertyUseType` has 1697 (50.3%) missing values	Missing
`SecondLargestPropertyUseTypeGFA` has 1697 (50.3%) missing values	Missing
`ThirdLargestPropertyUseType` has 2780 (82.3%) missing values	Missing
`ThirdLargestPropertyUseTypeGFA` has 2780 (82.3%) missing values	Missing
`YearsENERGYSTARCertified` has 3257 (96.5%) missing values	Missing
`ENERGYSTARScore` has 843 (25.0%) missing values	Missing
`Comments` has 3376 (100.0%) missing values	Missing
`Outlier` has 3344 (99.1%) missing values	Missing
`NumberofBuildings` is highly skewed (γ1 = 43.39499472)	Skewed
`PropertyGFATotal` is highly skewed (γ1 = 24.12940742)	Skewed
`PropertyGFABuilding(s)` is highly skewed (γ1 = 27.62439064)	Skewed
`LargestPropertyUseTypeGFA` is highly skewed (γ1 = 30.09595071)	Skewed
`SiteEnergyUse(kBtu)` is highly skewed (γ1 = 24.84197927)	Skewed
`SteamUse(kBtu)` is highly skewed (γ1 = 26.72088824)	Skewed
`Electricity(kWh)` is highly skewed (γ1 = 28.72846386)	Skewed
`Electricity(kBtu)` is highly skewed (γ1 = 28.72846389)	Skewed
`NaturalGas(therms)` is highly skewed (γ1 = 30.03889031)	Skewed
`NaturalGas(kBtu)` is highly skewed (γ1 = 30.03889028)	Skewed
`OSEBuildingID` has unique values	Unique
`Comments` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`NumberofBuildings` has 92 (2.7%) zeros	Zeros
`PropertyGFAParking` has 2872 (85.1%) zeros	Zeros
`SecondLargestPropertyUseTypeGFA` has 126 (3.7%) zeros	Zeros
`ThirdLargestPropertyUseTypeGFA` has 48 (1.4%) zeros	Zeros
`SourceEUIWN(kBtu/sf)` has 36 (1.1%) zeros	Zeros
`SteamUse(kBtu)` has 3237 (95.9%) zeros	Zeros
`NaturalGas(therms)` has 1258 (37.3%) zeros	Zeros
`NaturalGas(kBtu)` has 1258 (37.3%) zeros	Zeros

Reproduction

Analysis started	2024-06-19 20:00:34.495778
Analysis finished	2024-06-19 20:00:35.068347
Duration	0.57 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

OSEBuildingID
Real number (ℝ)

UNIQUE

Distinct	3376
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21208.99111

Minimum	1
Maximum	50226
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	1
5-th percentile	275.5
Q1	19990.75
median	23112
Q3	25994.25
95-th percentile	49784.25
Maximum	50226
Range	50225
Interquartile range (IQR)	6003.5

Descriptive statistics

Standard deviation	12223.75701
Coefficient of variation (CV)	0.5763478776
Kurtosis	0.6508667434
Mean	21208.99111
Median Absolute Deviation (MAD)	3012.5
Skewness	-0.008278915001
Sum	71601554
Variance	149420235.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
25062	1	< 0.1%
24943	1	< 0.1%
24948	1	< 0.1%
24955	1	< 0.1%
24958	1	< 0.1%
24959	1	< 0.1%
24976	1	< 0.1%
24987	1	< 0.1%
24989	1	< 0.1%
Other values (3366)	3366	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
5	1	< 0.1%
8	1	< 0.1%

Value	Count	Frequency (%)
50226	1	< 0.1%
50225	1	< 0.1%
50224	1	< 0.1%
50223	1	< 0.1%
50222	1	< 0.1%

DataYear
Real number (ℝ)

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2016

Minimum	2016
Maximum	2016
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	2016
5-th percentile	2016
Q1	2016
median	2016
Q3	2016
95-th percentile	2016
Maximum	2016
Range	0
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0
Coefficient of variation (CV)	0
Kurtosis	0
Mean	2016
Median Absolute Deviation (MAD)	0
Skewness	0
Sum	6806016
Variance	0
Monotonicity	Increasing

Histogram with fixed size bins (bins=1)

Value	Count	Frequency (%)
2016	3376	100.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2016	3376	100.0%

Value	Count	Frequency (%)
2016	3376	100.0%

BuildingType
Text

Distinct	8
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	26.5 KiB

Length

Max length	20
Median length	20
Mean length	17.16735782
Min length	6

Characters and Unicode

Total characters	57957
Distinct characters	40
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	NonResidential
2nd row	NonResidential
3rd row	NonResidential
4th row	NonResidential
5th row	NonResidential

Value	Count	Frequency (%)
multifamily	1708	24.5%
nonresidential	1546	22.2%
lr	1018	14.6%
1-4	1018	14.6%
mr	580	8.3%
5-9	580	8.3%
hr	110	1.6%
10	110	1.6%
sps-district	98	1.4%
k-12	98	1.4%
Other values (3)	110	1.6%

Most occurring characters

Value	Count	Frequency (%)
i	6704	11.6%
l	4962	8.6%
	3600	6.2%
t	3450	6.0%
a	3278	5.7%
R	3168	5.5%
n	3092	5.3%
e	3092	5.3%
M	2288	3.9%
-	1794	3.1%
Other values (30)	22529	38.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	57957	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	6704	11.6%
l	4962	8.6%
	3600	6.2%
t	3450	6.0%
a	3278	5.7%
R	3168	5.5%
n	3092	5.3%
e	3092	5.3%
M	2288	3.9%
-	1794	3.1%
Other values (30)	22529	38.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	57957	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	6704	11.6%
l	4962	8.6%
	3600	6.2%
t	3450	6.0%
a	3278	5.7%
R	3168	5.5%
n	3092	5.3%
e	3092	5.3%
M	2288	3.9%
-	1794	3.1%
Other values (30)	22529	38.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	57957	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	6704	11.6%
l	4962	8.6%
	3600	6.2%
t	3450	6.0%
a	3278	5.7%
R	3168	5.5%
n	3092	5.3%
e	3092	5.3%
M	2288	3.9%
-	1794	3.1%
Other values (30)	22529	38.9%

PrimaryPropertyType
Text

Distinct	24
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	26.5 KiB

Length

Max length	27
Median length	22
Mean length	17.18927725
Min length	5

Characters and Unicode

Total characters	58031
Distinct characters	43
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Hotel
2nd row	Hotel
3rd row	Hotel
4th row	Hotel
5th row	Hotel

Value	Count	Frequency (%)
multifamily	1656	23.6%
low-rise	987	14.1%
mid-rise	564	8.0%
office	508	7.2%
small	293	4.2%
and	293	4.2%
mid-sized	293	4.2%
other	256	3.6%
warehouse	199	2.8%
large	173	2.5%
Other values (28)	1794	25.6%

Most occurring characters

Value	Count	Frequency (%)
i	7607	13.1%
e	4535	7.8%
l	4427	7.6%
	3640	6.3%
a	3045	5.2%
t	2796	4.8%
f	2712	4.7%
M	2685	4.6%
-	2409	4.2%
s	2182	3.8%
Other values (33)	21993	37.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	58031	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	7607	13.1%
e	4535	7.8%
l	4427	7.6%
	3640	6.3%
a	3045	5.2%
t	2796	4.8%
f	2712	4.7%
M	2685	4.6%
-	2409	4.2%
s	2182	3.8%
Other values (33)	21993	37.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	58031	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	7607	13.1%
e	4535	7.8%
l	4427	7.6%
	3640	6.3%
a	3045	5.2%
t	2796	4.8%
f	2712	4.7%
M	2685	4.6%
-	2409	4.2%
s	2182	3.8%
Other values (33)	21993	37.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	58031	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	7607	13.1%
e	4535	7.8%
l	4427	7.6%
	3640	6.3%
a	3045	5.2%
t	2796	4.8%
f	2712	4.7%
M	2685	4.6%
-	2409	4.2%
s	2182	3.8%
Other values (33)	21993	37.9%

PropertyName
Text

Distinct	3362
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Memory size	26.5 KiB

Length

Max length	72
Median length	53
Mean length	19.40017773
Min length	2

Characters and Unicode

Total characters	65495
Distinct characters	76
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3349 ?
Unique (%)	99.2%

Sample

1st row	Mayflower park hotel
2nd row	Paramount Hotel
3rd row	5673-The Westin Seattle
4th row	HOTEL MAX
5th row	WARWICK SEATTLE HOTEL (ID8)

Value	Count	Frequency (%)
apartments	426	4.3%
building	329	3.4%
	248	2.5%
the	166	1.7%
seattle	158	1.6%
center	127	1.3%
condominium	123	1.3%
court	104	1.1%
park	103	1.1%
place	101	1.0%
Other values (3149)	7914	80.8%

Most occurring characters

Value	Count	Frequency (%)
	6431	9.8%
e	5232	8.0%
a	3917	6.0%
t	3857	5.9%
n	3820	5.8%
i	3400	5.2%
r	3374	5.2%
o	3084	4.7%
l	2584	3.9%
s	2148	3.3%
Other values (66)	27648	42.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	65495	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	6431	9.8%
e	5232	8.0%
a	3917	6.0%
t	3857	5.9%
n	3820	5.8%
i	3400	5.2%
r	3374	5.2%
o	3084	4.7%
l	2584	3.9%
s	2148	3.3%
Other values (66)	27648	42.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	65495	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	6431	9.8%
e	5232	8.0%
a	3917	6.0%
t	3857	5.9%
n	3820	5.8%
i	3400	5.2%
r	3374	5.2%
o	3084	4.7%
l	2584	3.9%
s	2148	3.3%
Other values (66)	27648	42.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	65495	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	6431	9.8%
e	5232	8.0%
a	3917	6.0%
t	3857	5.9%
n	3820	5.8%
i	3400	5.2%
r	3374	5.2%
o	3084	4.7%
l	2584	3.9%
s	2148	3.3%
Other values (66)	27648	42.2%

Address
Text

Distinct	3354
Distinct (%)	99.3%
Missing	0
Missing (%)	0.0%
Memory size	26.5 KiB

Length

Max length	41
Median length	34
Mean length	17.23992891
Min length	8

Characters and Unicode

Total characters	58202
Distinct characters	70
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3338 ?
Unique (%)	98.9%

Sample

1st row	405 Olive way
2nd row	724 Pine street
3rd row	1900 5th Avenue
4th row	620 STEWART ST
5th row	401 LENORA ST

Value	Count	Frequency (%)
ave	1608	12.5%
st	590	4.6%
ne	462	3.6%
s	462	3.6%
n	407	3.2%
avenue	388	3.0%
way	321	2.5%
e	309	2.4%
sw	230	1.8%
street	225	1.7%
Other values (2292)	7872	61.1%

Most occurring characters

Value	Count	Frequency (%)
	9521	16.4%
e	4223	7.3%
1	3286	5.6%
t	2929	5.0%
0	2832	4.9%
A	2299	4.0%
v	1977	3.4%
2	1969	3.4%
S	1874	3.2%
n	1638	2.8%
Other values (60)	25654	44.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	58202	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	9521	16.4%
e	4223	7.3%
1	3286	5.6%
t	2929	5.0%
0	2832	4.9%
A	2299	4.0%
v	1977	3.4%
2	1969	3.4%
S	1874	3.2%
n	1638	2.8%
Other values (60)	25654	44.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	58202	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	9521	16.4%
e	4223	7.3%
1	3286	5.6%
t	2929	5.0%
0	2832	4.9%
A	2299	4.0%
v	1977	3.4%
2	1969	3.4%
S	1874	3.2%
n	1638	2.8%
Other values (60)	25654	44.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	58202	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	9521	16.4%
e	4223	7.3%
1	3286	5.6%
t	2929	5.0%
0	2832	4.9%
A	2299	4.0%
v	1977	3.4%
2	1969	3.4%
S	1874	3.2%
n	1638	2.8%
Other values (60)	25654	44.1%

City
Text

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.5 KiB

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	23632
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Seattle
2nd row	Seattle
3rd row	Seattle
4th row	Seattle
5th row	Seattle

Value	Count	Frequency (%)
seattle	3376	100.0%

Most occurring characters

Value	Count	Frequency (%)
e	6752	28.6%
t	6752	28.6%
S	3376	14.3%
a	3376	14.3%
l	3376	14.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	23632	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	6752	28.6%
t	6752	28.6%
S	3376	14.3%
a	3376	14.3%
l	3376	14.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	23632	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	6752	28.6%
t	6752	28.6%
S	3376	14.3%
a	3376	14.3%
l	3376	14.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	23632	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	6752	28.6%
t	6752	28.6%
S	3376	14.3%
a	3376	14.3%
l	3376	14.3%

State
Text

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.5 KiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	6752
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	WA
2nd row	WA
3rd row	WA
4th row	WA
5th row	WA

Value	Count	Frequency (%)
wa	3376	100.0%

Most occurring characters

Value	Count	Frequency (%)
W	3376	50.0%
A	3376	50.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6752	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
W	3376	50.0%
A	3376	50.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6752	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
W	3376	50.0%
A	3376	50.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6752	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
W	3376	50.0%
A	3376	50.0%

ZipCode
Real number (ℝ)

Distinct	55
Distinct (%)	1.6%
Missing	16
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	98116.94911

Minimum	98006
Maximum	98272
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	98006
5-th percentile	98101
Q1	98105
median	98115
Q3	98122
95-th percentile	98144
Maximum	98272
Range	266
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	18.61520454
Coefficient of variation (CV)	0.0001897246573
Kurtosis	10.49296463
Mean	98116.94911
Median Absolute Deviation (MAD)	10
Skewness	1.99966218
Sum	329672949
Variance	346.5258402
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
98109	294	8.7%
98104	251	7.4%
98122	243	7.2%
98101	230	6.8%
98105	191	5.7%
98134	186	5.5%
98121	186	5.5%
98102	169	5.0%
98119	167	4.9%
98103	161	4.8%
Other values (45)	1282	38.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
98006	1	< 0.1%
98011	1	< 0.1%
98012	1	< 0.1%
98013	2	0.1%
98020	1	< 0.1%

Value	Count	Frequency (%)
98272	1	< 0.1%
98204	1	< 0.1%
98199	70	2.1%
98198	1	< 0.1%
98195	10	0.3%

TaxParcelIdentificationNumber
Text

Distinct	3268
Distinct (%)	96.8%
Missing	0
Missing (%)	0.0%
Memory size	26.5 KiB

Length

Max length	25
Median length	10
Mean length	10.00503555
Min length	9

Characters and Unicode

Total characters	33777
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3191 ?
Unique (%)	94.5%

Sample

1st row	0659000030
2nd row	0659000220
3rd row	0659000475
4th row	0659000640
5th row	0659000970

Value	Count	Frequency (%)
1625049001	8	0.2%
0925049346	5	0.1%
0002400002	5	0.1%
3224049012	5	0.1%
3624039009	4	0.1%
8632880000	4	0.1%
7666203240	4	0.1%
0225049077	3	0.1%
8809700040	3	0.1%
1985200003	3	0.1%
Other values (3259)	3334	98.7%

Most occurring characters

Value	Count	Frequency (%)
0	11368	33.7%
2	3168	9.4%
5	2946	8.7%
6	2713	8.0%
1	2691	8.0%
9	2377	7.0%
7	2363	7.0%
4	2164	6.4%
3	2071	6.1%
8	1909	5.7%
Other values (5)	7	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	33777	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	11368	33.7%
2	3168	9.4%
5	2946	8.7%
6	2713	8.0%
1	2691	8.0%
9	2377	7.0%
7	2363	7.0%
4	2164	6.4%
3	2071	6.1%
8	1909	5.7%
Other values (5)	7	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	33777	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	11368	33.7%
2	3168	9.4%
5	2946	8.7%
6	2713	8.0%
1	2691	8.0%
9	2377	7.0%
7	2363	7.0%
4	2164	6.4%
3	2071	6.1%
8	1909	5.7%
Other values (5)	7	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	33777	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	11368	33.7%
2	3168	9.4%
5	2946	8.7%
6	2713	8.0%
1	2691	8.0%
9	2377	7.0%
7	2363	7.0%
4	2164	6.4%
3	2071	6.1%
8	1909	5.7%
Other values (5)	7	< 0.1%

CouncilDistrictCode
Real number (ℝ)

Distinct	7
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.439277251

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	4
Q3	7
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.120625473
Coefficient of variation (CV)	0.4776961097
Kurtosis	-1.444891233
Mean	4.439277251
Median Absolute Deviation (MAD)	2
Skewness	-0.07015381123
Sum	14987
Variance	4.497052396
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
7	1037	30.7%
3	596	17.7%
2	509	15.1%
4	367	10.9%
5	338	10.0%
1	282	8.4%
6	247	7.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	282	8.4%
2	509	15.1%
3	596	17.7%
4	367	10.9%
5	338	10.0%

Value	Count	Frequency (%)
7	1037	30.7%
6	247	7.3%
5	338	10.0%
4	367	10.9%
3	596	17.7%

Neighborhood
Text

Distinct	19
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	26.5 KiB

Length

Max length	22
Median length	16
Mean length	10.11404028
Min length	4

Characters and Unicode

Total characters	34145
Distinct characters	34
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	DOWNTOWN
2nd row	DOWNTOWN
3rd row	DOWNTOWN
4th row	DOWNTOWN
5th row	DOWNTOWN

Value	Count	Frequency (%)
downtown	573	10.9%
east	453	8.6%
magnolia	423	8.0%
	423	8.0%
queen	423	8.0%
anne	423	8.0%
greater	375	7.1%
duwamish	375	7.1%
northeast	280	5.3%
union	251	4.8%
Other values (9)	1273	24.1%

Most occurring characters

Value	Count	Frequency (%)
N	4136	12.1%
E	3744	11.0%
A	3457	10.1%
T	3155	9.2%
O	2719	8.0%
W	1897	5.6%
	1896	5.6%
S	1841	5.4%
R	1700	5.0%
U	1310	3.8%
Other values (24)	8290	24.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	34145	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	4136	12.1%
E	3744	11.0%
A	3457	10.1%
T	3155	9.2%
O	2719	8.0%
W	1897	5.6%
	1896	5.6%
S	1841	5.4%
R	1700	5.0%
U	1310	3.8%
Other values (24)	8290	24.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	34145	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	4136	12.1%
E	3744	11.0%
A	3457	10.1%
T	3155	9.2%
O	2719	8.0%
W	1897	5.6%
	1896	5.6%
S	1841	5.4%
R	1700	5.0%
U	1310	3.8%
Other values (24)	8290	24.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	34145	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	4136	12.1%
E	3744	11.0%
A	3457	10.1%
T	3155	9.2%
O	2719	8.0%
W	1897	5.6%
	1896	5.6%
S	1841	5.4%
R	1700	5.0%
U	1310	3.8%
Other values (24)	8290	24.3%

Latitude
Real number (ℝ)

Distinct	2876
Distinct (%)	85.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.62403312

Minimum	47.49917
Maximum	47.73387
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	47.49917
5-th percentile	47.5417125
Q1	47.59986
median	47.618675
Q3	47.657115
95-th percentile	47.713
Maximum	47.73387
Range	0.2347
Interquartile range (IQR)	0.057255

Descriptive statistics

Standard deviation	0.04775842495
Coefficient of variation (CV)	0.001002821933
Kurtosis	-0.1411603852
Mean	47.62403312
Median Absolute Deviation (MAD)	0.028385
Skewness	0.1400447677
Sum	160778.7358
Variance	0.002280867154
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
47.66246	9	0.3%
47.61598	7	0.2%
47.62208	6	0.2%
47.62395	5	0.1%
47.61543	5	0.1%
47.52549	5	0.1%
47.6139	4	0.1%
47.61048	4	0.1%
47.60071	4	0.1%
47.59938	4	0.1%
Other values (2866)	3323	98.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
47.49917	1	< 0.1%
47.50061895	1	< 0.1%
47.50224	1	< 0.1%
47.50959	1	< 0.1%
47.5097	1	< 0.1%

Value	Count	Frequency (%)
47.73387	1	< 0.1%
47.73375	1	< 0.1%
47.73368	1	< 0.1%
47.7336	1	< 0.1%
47.73357	1	< 0.1%

Longitude
Real number (ℝ)

Distinct	2656
Distinct (%)	78.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-122.3347952

Minimum	-122.41425
Maximum	-122.2209659
Zeros	0
Zeros (%)	0.0%
Negative	3376
Negative (%)	100.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	-122.41425
5-th percentile	-122.3865425
Q1	-122.3506625
median	-122.332495
Q3	-122.3194075
95-th percentile	-122.2898275
Maximum	-122.2209659
Range	0.1932841
Interquartile range (IQR)	0.031255

Descriptive statistics

Standard deviation	0.02720328528
Coefficient of variation (CV)	-0.0002223675221
Kurtosis	0.2623984964
Mean	-122.3347952
Median Absolute Deviation (MAD)	0.01513
Skewness	-0.1375264709
Sum	-413002.2686
Variance	0.00074001873
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-122.29898	8	0.2%
-122.35398	7	0.2%
-122.32468	6	0.2%
-122.33369	6	0.2%
-122.33379	6	0.2%
-122.33064	5	0.1%
-122.31769	5	0.1%
-122.32417	5	0.1%
-122.32592	5	0.1%
-122.32585	4	0.1%
Other values (2646)	3319	98.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-122.41425	1	< 0.1%
-122.41182	1	< 0.1%
-122.41178	1	< 0.1%
-122.41169	1	< 0.1%
-122.41037	1	< 0.1%

Value	Count	Frequency (%)
-122.2209659	1	< 0.1%
-122.25864	1	< 0.1%
-122.26028	1	< 0.1%
-122.26034	1	< 0.1%
-122.26166	2	0.1%

YearBuilt
Real number (ℝ)

Distinct	113
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1968.573164

Minimum	1900
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	1900
5-th percentile	1908
Q1	1948
median	1975
Q3	1997
95-th percentile	2012
Maximum	2015
Range	115
Interquartile range (IQR)	49

Descriptive statistics

Standard deviation	33.08815578
Coefficient of variation (CV)	0.01680819204
Kurtosis	-0.8713417711
Mean	1968.573164
Median Absolute Deviation (MAD)	24
Skewness	-0.5394445573
Sum	6645903
Variance	1094.826053
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2000	72	2.1%
2014	67	2.0%
1989	67	2.0%
2008	66	2.0%
1988	64	1.9%
1999	64	1.9%
1968	63	1.9%
1990	60	1.8%
2001	60	1.8%
2002	59	1.7%
Other values (103)	2734	81.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1900	55	1.6%
1901	8	0.2%
1902	11	0.3%
1903	4	0.1%
1904	15	0.4%

Value	Count	Frequency (%)
2015	37	1.1%
2014	67	2.0%
2013	51	1.5%
2012	35	1.0%
2011	15	0.4%

NumberofBuildings
Real number (ℝ)

SKEWED ZEROS

Distinct	17
Distinct (%)	0.5%
Missing	8
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	1.106888361

Minimum	0
Maximum	111
Zeros	92
Zeros (%)	2.7%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	111
Range	111
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.108401751
Coefficient of variation (CV)	1.904800723
Kurtosis	2205.296217
Mean	1.106888361
Median Absolute Deviation (MAD)	0
Skewness	43.39499472
Sum	3728
Variance	4.445357942
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
1	3175	94.0%
0	92	2.7%
2	37	1.1%
3	22	0.7%
4	12	0.4%
5	10	0.3%
6	5	0.1%
8	3	0.1%
10	2	0.1%
9	2	0.1%
Other values (7)	8	0.2%
(Missing)	8	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	92	2.7%
1	3175	94.0%
2	37	1.1%
3	22	0.7%
4	12	0.4%

Value	Count	Frequency (%)
111	1	< 0.1%
27	1	< 0.1%
23	1	< 0.1%
16	1	< 0.1%
14	2	0.1%

NumberofFloors
Real number (ℝ)

Distinct	50
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.709123223

Minimum	0
Maximum	99
Zeros	16
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	4
Q3	5
95-th percentile	12
Maximum	99
Range	99
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	5.494464797
Coefficient of variation (CV)	1.166770232
Kurtosis	55.95064463
Mean	4.709123223
Median Absolute Deviation (MAD)	2
Skewness	5.922339745
Sum	15898
Variance	30.18914341
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	692	20.5%
3	692	20.5%
1	466	13.8%
2	439	13.0%
6	306	9.1%
5	295	8.7%
7	148	4.4%
8	64	1.9%
10	32	0.9%
11	32	0.9%
Other values (40)	210	6.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16	0.5%
1	466	13.8%
2	439	13.0%
3	692	20.5%
4	692	20.5%

Value	Count	Frequency (%)
99	1	< 0.1%
76	1	< 0.1%
63	1	< 0.1%
56	1	< 0.1%
55	1	< 0.1%

PropertyGFATotal
Real number (ℝ)

SKEWED

Distinct	3195
Distinct (%)	94.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	94833.53732

Minimum	11285
Maximum	9320156
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	11285
5-th percentile	21291.5
Q1	28487
median	44175
Q3	90992
95-th percentile	320096
Maximum	9320156
Range	9308871
Interquartile range (IQR)	62505

Descriptive statistics

Standard deviation	218837.6071
Coefficient of variation (CV)	2.30759722
Kurtosis	946.2394908
Mean	94833.53732
Median Absolute Deviation (MAD)	19739.5
Skewness	24.12940742
Sum	320158022
Variance	4.788989829 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36000	9	0.3%
25920	8	0.2%
28800	7	0.2%
21600	7	0.2%
24000	6	0.2%
22320	4	0.1%
30720	4	0.1%
30240	4	0.1%
43380	3	0.1%
31900	3	0.1%
Other values (3185)	3321	98.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
11285	1	< 0.1%
11685	1	< 0.1%
11968	1	< 0.1%
12294	1	< 0.1%
12769	1	< 0.1%

Value	Count	Frequency (%)
9320156	1	< 0.1%
2200000	1	< 0.1%
1952220	1	< 0.1%
1765970	1	< 0.1%
1605578	1	< 0.1%

PropertyGFAParking
Real number (ℝ)

ZEROS

Distinct	496
Distinct (%)	14.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8001.526066

Minimum	0
Maximum	512608
Zeros	2872
Zeros (%)	85.1%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	46400.75
Maximum	512608
Range	512608
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	32326.72393
Coefficient of variation (CV)	4.040069814
Kurtosis	58.97489179
Mean	8001.526066
Median Absolute Deviation (MAD)	0
Skewness	6.651190825
Sum	27013152
Variance	1045017080
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2872	85.1%
13320	3	0.1%
10800	2	0.1%
20416	2	0.1%
30000	2	0.1%
22000	2	0.1%
100176	2	0.1%
25800	2	0.1%
12960	2	0.1%
756	1	< 0.1%
Other values (486)	486	14.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2872	85.1%
38	1	< 0.1%
260	1	< 0.1%
415	1	< 0.1%
604	1	< 0.1%

Value	Count	Frequency (%)
512608	1	< 0.1%
407795	1	< 0.1%
389860	1	< 0.1%
368980	1	< 0.1%
335109	1	< 0.1%

PropertyGFABuilding(s)
Real number (ℝ)

SKEWED

Distinct	3193
Distinct (%)	94.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	86832.01126

Minimum	3636
Maximum	9320156
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	3636
5-th percentile	21021
Q1	27756
median	43216
Q3	84276.25
95-th percentile	282658.5
Maximum	9320156
Range	9316520
Interquartile range (IQR)	56520.25

Descriptive statistics

Standard deviation	207939.8119
Coefficient of variation (CV)	2.39473679
Kurtosis	1161.360271
Mean	86832.01126
Median Absolute Deviation (MAD)	18958.5
Skewness	27.62439064
Sum	293144870
Variance	4.323896538 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36000	9	0.3%
25920	8	0.2%
21600	7	0.2%
28800	7	0.2%
24000	6	0.2%
30240	4	0.1%
22320	4	0.1%
30720	4	0.1%
25800	3	0.1%
31900	3	0.1%
Other values (3183)	3321	98.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3636	1	< 0.1%
10925	1	< 0.1%
11285	1	< 0.1%
11440	1	< 0.1%
11685	1	< 0.1%

Value	Count	Frequency (%)
9320156	1	< 0.1%
2200000	1	< 0.1%
1765970	1	< 0.1%
1632820	1	< 0.1%
1592914	1	< 0.1%

ListOfAllPropertyUseTypes
Text

Distinct	466
Distinct (%)	13.8%
Missing	9
Missing (%)	0.3%
Memory size	26.5 KiB

Length

Max length	255
Median length	162
Mean length	25.93436293
Min length	5

Characters and Unicode

Total characters	87321
Distinct characters	52
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	314 ?
Unique (%)	9.3%

Sample

1st row	Hotel
2nd row	Hotel, Parking, Restaurant
3rd row	Hotel
4th row	Hotel
5th row	Hotel, Parking, Swimming Pool

Value	Count	Frequency (%)
multifamily	1707	17.2%
housing	1707	17.2%
parking	1087	11.0%
office	958	9.7%
store	472	4.8%
other	419	4.2%
retail	404	4.1%
warehouse	278	2.8%
non-refrigerated	261	2.6%
	181	1.8%
Other values (97)	2430	24.5%

Most occurring characters

Value	Count	Frequency (%)
i	9364	10.7%
	6537	7.5%
e	5683	6.5%
a	5252	6.0%
l	4957	5.7%
t	4946	5.7%
u	4261	4.9%
r	4247	4.9%
n	4177	4.8%
o	4014	4.6%
Other values (42)	33883	38.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	87321	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	9364	10.7%
	6537	7.5%
e	5683	6.5%
a	5252	6.0%
l	4957	5.7%
t	4946	5.7%
u	4261	4.9%
r	4247	4.9%
n	4177	4.8%
o	4014	4.6%
Other values (42)	33883	38.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	87321	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	9364	10.7%
	6537	7.5%
e	5683	6.5%
a	5252	6.0%
l	4957	5.7%
t	4946	5.7%
u	4261	4.9%
r	4247	4.9%
n	4177	4.8%
o	4014	4.6%
Other values (42)	33883	38.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	87321	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	9364	10.7%
	6537	7.5%
e	5683	6.5%
a	5252	6.0%
l	4957	5.7%
t	4946	5.7%
u	4261	4.9%
r	4247	4.9%
n	4177	4.8%
o	4014	4.6%
Other values (42)	33883	38.8%

LargestPropertyUseType
Text

Distinct	56
Distinct (%)	1.7%
Missing	20
Missing (%)	0.6%
Memory size	26.5 KiB

Length

Max length	52
Median length	19
Mean length	16.25595948
Min length	5

Characters and Unicode

Total characters	54555
Distinct characters	51
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	0.3%

Sample

1st row	Hotel
2nd row	Hotel
3rd row	Hotel
4th row	Hotel
5th row	Hotel

Value	Count	Frequency (%)
multifamily	1667	27.1%
housing	1667	27.1%
office	543	8.8%
warehouse	211	3.4%
non-refrigerated	199	3.2%
other	179	2.9%
store	140	2.3%
k-12	139	2.3%
school	139	2.3%
facility	100	1.6%
Other values (79)	1168	19.0%

Most occurring characters

Value	Count	Frequency (%)
i	6825	12.5%
l	4130	7.6%
u	3794	7.0%
t	3095	5.7%
o	3071	5.6%
e	3031	5.6%
f	3005	5.5%
a	2800	5.1%
	2796	5.1%
n	2391	4.4%
Other values (41)	19617	36.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	54555	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	6825	12.5%
l	4130	7.6%
u	3794	7.0%
t	3095	5.7%
o	3071	5.6%
e	3031	5.6%
f	3005	5.5%
a	2800	5.1%
	2796	5.1%
n	2391	4.4%
Other values (41)	19617	36.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	54555	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	6825	12.5%
l	4130	7.6%
u	3794	7.0%
t	3095	5.7%
o	3071	5.6%
e	3031	5.6%
f	3005	5.5%
a	2800	5.1%
	2796	5.1%
n	2391	4.4%
Other values (41)	19617	36.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	54555	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	6825	12.5%
l	4130	7.6%
u	3794	7.0%
t	3095	5.7%
o	3071	5.6%
e	3031	5.6%
f	3005	5.5%
a	2800	5.1%
	2796	5.1%
n	2391	4.4%
Other values (41)	19617	36.0%

LargestPropertyUseTypeGFA
Real number (ℝ)

SKEWED

Distinct	3122
Distinct (%)	93.0%
Missing	20
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	79177.63856

Minimum	5656
Maximum	9320156
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	5656
5-th percentile	17609
Q1	25094.75
median	39894
Q3	76200.25
95-th percentile	243388.5
Maximum	9320156
Range	9314500
Interquartile range (IQR)	51105.5

Descriptive statistics

Standard deviation	201703.4075
Coefficient of variation (CV)	2.547479455
Kurtosis	1320.609838
Mean	79177.63856
Median Absolute Deviation (MAD)	17574
Skewness	30.09595071
Sum	265720155
Variance	4.068426459 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22000	9	0.3%
24000	9	0.3%
30000	8	0.2%
21600	8	0.2%
20000	7	0.2%
25000	6	0.2%
28800	5	0.1%
45000	5	0.1%
36000	5	0.1%
15000	5	0.1%
Other values (3112)	3289	97.4%
(Missing)	20	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5656	1	< 0.1%
6455	1	< 0.1%
6601	1	< 0.1%
6900	1	< 0.1%
7245	1	< 0.1%

Value	Count	Frequency (%)
9320156	1	< 0.1%
1719643	1	< 0.1%
1680937	1	< 0.1%
1639334	1	< 0.1%
1585960	1	< 0.1%

SecondLargestPropertyUseType
Text

MISSING

Distinct	50
Distinct (%)	3.0%
Missing	1697
Missing (%)	50.3%
Memory size	26.5 KiB

Length

Max length	52
Median length	7
Mean length	9.177486599
Min length	5

Characters and Unicode

Total characters	15409
Distinct characters	52
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11 ?
Unique (%)	0.7%

Sample

1st row	Parking
2nd row	Parking
3rd row	Parking
4th row	Parking
5th row	Parking

Value	Count	Frequency (%)
parking	976	45.5%
office	228	10.6%
store	170	7.9%
retail	155	7.2%
other	94	4.4%
restaurant	40	1.9%
	37	1.7%
warehouse	35	1.6%
non-refrigerated	33	1.5%
services	20	0.9%
Other values (74)	355	16.6%

Most occurring characters

Value	Count	Frequency (%)
i	1647	10.7%
r	1600	10.4%
a	1494	9.7%
n	1222	7.9%
e	1193	7.7%
g	1059	6.9%
P	1002	6.5%
k	1001	6.5%
t	773	5.0%
f	517	3.4%
Other values (42)	3901	25.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	15409	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	1647	10.7%
r	1600	10.4%
a	1494	9.7%
n	1222	7.9%
e	1193	7.7%
g	1059	6.9%
P	1002	6.5%
k	1001	6.5%
t	773	5.0%
f	517	3.4%
Other values (42)	3901	25.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	15409	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	1647	10.7%
r	1600	10.4%
a	1494	9.7%
n	1222	7.9%
e	1193	7.7%
g	1059	6.9%
P	1002	6.5%
k	1001	6.5%
t	773	5.0%
f	517	3.4%
Other values (42)	3901	25.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	15409	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	1647	10.7%
r	1600	10.4%
a	1494	9.7%
n	1222	7.9%
e	1193	7.7%
g	1059	6.9%
P	1002	6.5%
k	1001	6.5%
t	773	5.0%
f	517	3.4%
Other values (42)	3901	25.3%

SecondLargestPropertyUseTypeGFA
Real number (ℝ)

MISSING ZEROS

Distinct	1352
Distinct (%)	80.5%
Missing	1697
Missing (%)	50.3%
Infinite	0
Infinite (%)	0.0%
Mean	28444.07582

Minimum	0
Maximum	686750
Zeros	126
Zeros (%)	3.7%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5000
median	10664
Q3	26640
95-th percentile	117338.6
Maximum	686750
Range	686750
Interquartile range (IQR)	21640

Descriptive statistics

Standard deviation	54392.91793
Coefficient of variation (CV)	1.912275803
Kurtosis	36.30208308
Mean	28444.07582
Median Absolute Deviation (MAD)	7564
Skewness	5.033480723
Sum	47757603.3
Variance	2958589521
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	126	3.7%
5000	14	0.4%
7200	12	0.4%
15000	12	0.4%
6000	12	0.4%
7000	9	0.3%
10000	8	0.2%
8000	7	0.2%
4000	7	0.2%
1500	6	0.2%
Other values (1342)	1466	43.4%
(Missing)	1697	50.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	126	3.7%
2	1	< 0.1%
40	1	< 0.1%
200	1	< 0.1%
220	1	< 0.1%

Value	Count	Frequency (%)
686750	1	< 0.1%
639931	1	< 0.1%
441551	1	< 0.1%
438756	1	< 0.1%
389860	1	< 0.1%

ThirdLargestPropertyUseType
Text

MISSING

Distinct	44
Distinct (%)	7.4%
Missing	2780
Missing (%)	82.3%
Memory size	26.5 KiB

Length

Max length	52
Median length	27
Mean length	11.9966443
Min length	5

Characters and Unicode

Total characters	7150
Distinct characters	51
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	1.5%

Sample

1st row	Restaurant
2nd row	Swimming Pool
3rd row	Data Center
4th row	Swimming Pool
5th row	Office

Value	Count	Frequency (%)
office	127	13.1%
store	115	11.9%
retail	110	11.3%
other	77	7.9%
parking	71	7.3%
restaurant	59	6.1%
swimming	29	3.0%
pool	29	3.0%
	28	2.9%
warehouse	20	2.1%
Other values (59)	305	31.4%

Most occurring characters

Value	Count	Frequency (%)
e	845	11.8%
t	617	8.6%
i	569	8.0%
a	562	7.9%
r	518	7.2%
	374	5.2%
o	333	4.7%
n	328	4.6%
l	303	4.2%
f	289	4.0%
Other values (41)	2412	33.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7150	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	845	11.8%
t	617	8.6%
i	569	8.0%
a	562	7.9%
r	518	7.2%
	374	5.2%
o	333	4.7%
n	328	4.6%
l	303	4.2%
f	289	4.0%
Other values (41)	2412	33.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7150	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	845	11.8%
t	617	8.6%
i	569	8.0%
a	562	7.9%
r	518	7.2%
	374	5.2%
o	333	4.7%
n	328	4.6%
l	303	4.2%
f	289	4.0%
Other values (41)	2412	33.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7150	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	845	11.8%
t	617	8.6%
i	569	8.0%
a	562	7.9%
r	518	7.2%
	374	5.2%
o	333	4.7%
n	328	4.6%
l	303	4.2%
f	289	4.0%
Other values (41)	2412	33.7%

ThirdLargestPropertyUseTypeGFA
Real number (ℝ)

MISSING ZEROS

Distinct	501
Distinct (%)	84.1%
Missing	2780
Missing (%)	82.3%
Infinite	0
Infinite (%)	0.0%
Mean	11738.67517

Minimum	0
Maximum	459748
Zeros	48
Zeros (%)	1.4%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2239
median	5043
Q3	10138.75
95-th percentile	41654.5
Maximum	459748
Range	459748
Interquartile range (IQR)	7899.75

Descriptive statistics

Standard deviation	29331.19929
Coefficient of variation (CV)	2.498680547
Kurtosis	114.1871141
Mean	11738.67517
Median Absolute Deviation (MAD)	3590.5
Skewness	9.196935797
Sum	6996250.399
Variance	860319251.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	48	1.4%
6000	7	0.2%
5000	6	0.2%
2000	5	0.1%
3000	5	0.1%
1000	4	0.1%
9000	4	0.1%
6200	3	0.1%
1250	3	0.1%
1500	3	0.1%
Other values (491)	508	15.0%
(Missing)	2780	82.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	48	1.4%
182	1	< 0.1%
187	1	< 0.1%
240	1	< 0.1%
250	1	< 0.1%

Value	Count	Frequency (%)
459748	1	< 0.1%
303910	1	< 0.1%
220303	1	< 0.1%
177210	1	< 0.1%
141450	1	< 0.1%

YearsENERGYSTARCertified
Text

MISSING

Distinct	65
Distinct (%)	54.6%
Missing	3257
Missing (%)	96.5%
Memory size	26.5 KiB

Length

Max length	60
Median length	52
Mean length	12.23529412
Min length	4

Characters and Unicode

Total characters	1456
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	49 ?
Unique (%)	41.2%

Sample

1st row	2016
2nd row	2016
3rd row	2014
4th row	2016
5th row	2016

Value	Count	Frequency (%)
2016	14	11.8%
20172016	8	6.7%
2017	7	5.9%
2014	6	5.0%
20162015	6	5.0%
2013	4	3.4%
2009	4	3.4%
20172015	3	2.5%
201620152014	3	2.5%
20152014	3	2.5%
Other values (55)	61	51.3%

Most occurring characters

Value	Count	Frequency (%)
0	474	32.6%
2	391	26.9%
1	303	20.8%
6	67	4.6%
5	51	3.5%
7	46	3.2%
4	38	2.6%
9	33	2.3%
3	29	2.0%
8	24	1.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1456	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	474	32.6%
2	391	26.9%
1	303	20.8%
6	67	4.6%
5	51	3.5%
7	46	3.2%
4	38	2.6%
9	33	2.3%
3	29	2.0%
8	24	1.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1456	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	474	32.6%
2	391	26.9%
1	303	20.8%
6	67	4.6%
5	51	3.5%
7	46	3.2%
4	38	2.6%
9	33	2.3%
3	29	2.0%
8	24	1.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1456	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	474	32.6%
2	391	26.9%
1	303	20.8%
6	67	4.6%
5	51	3.5%
7	46	3.2%
4	38	2.6%
9	33	2.3%
3	29	2.0%
8	24	1.6%

ENERGYSTARScore
Real number (ℝ)

MISSING

Distinct	100
Distinct (%)	3.9%
Missing	843
Missing (%)	25.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.91867351

Minimum	1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	1
5-th percentile	12
Q1	53
median	75
Q3	90
95-th percentile	99
Maximum	100
Range	99
Interquartile range (IQR)	37

Descriptive statistics

Standard deviation	26.87327089
Coefficient of variation (CV)	0.3956683707
Kurtosis	-0.2195668767
Mean	67.91867351
Median Absolute Deviation (MAD)	17
Skewness	-0.8594613198
Sum	172038
Variance	722.1726883
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	109	3.2%
98	72	2.1%
96	64	1.9%
89	58	1.7%
93	57	1.7%
92	53	1.6%
95	51	1.5%
94	49	1.5%
91	49	1.5%
99	49	1.5%
Other values (90)	1922	56.9%
(Missing)	843	25.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	36	1.1%
2	10	0.3%
3	13	0.4%
4	5	0.1%
5	10	0.3%

Value	Count	Frequency (%)
100	109	3.2%
99	49	1.5%
98	72	2.1%
97	48	1.4%
96	64	1.9%

SiteEUI(kBtu/sf)
Real number (ℝ)

Distinct	1085
Distinct (%)	32.2%
Missing	7
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	54.7321164

Minimum	0
Maximum	834.4000244
Zeros	16
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	16.97999992
Q1	27.89999962
median	38.59999847
Q3	60.40000153
95-th percentile	146.9
Maximum	834.4000244
Range	834.4000244
Interquartile range (IQR)	32.50000191

Descriptive statistics

Standard deviation	56.27312409
Coefficient of variation (CV)	1.028155456
Kurtosis	39.99456818
Mean	54.7321164
Median Absolute Deviation (MAD)	13.5
Skewness	4.981885737
Sum	184392.5001
Variance	3166.664495
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24.70000076	17	0.5%
28.79999924	17	0.5%
0	16	0.5%
24.20000076	16	0.5%
32	15	0.4%
26.39999962	14	0.4%
31.70000076	14	0.4%
28.89999962	14	0.4%
29.60000038	13	0.4%
22.79999924	13	0.4%
Other values (1075)	3220	95.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16	0.5%
0.400000006	1	< 0.1%
0.699999988	1	< 0.1%
1	1	< 0.1%
1.399999976	1	< 0.1%

Value	Count	Frequency (%)
834.4000244	1	< 0.1%
707.2999878	1	< 0.1%
696.7000122	1	< 0.1%
694.7000122	1	< 0.1%
639.7000122	1	< 0.1%

SiteEUIWN(kBtu/sf)
Real number (ℝ)

Distinct	1105
Distinct (%)	32.8%
Missing	6
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	57.03379823

Minimum	0
Maximum	834.4000244
Zeros	29
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	17.39999962
Q1	29.39999962
median	40.90000153
Q3	64.27500152
95-th percentile	149.155001
Maximum	834.4000244
Range	834.4000244
Interquartile range (IQR)	34.8750019

Descriptive statistics

Standard deviation	57.16333021
Coefficient of variation (CV)	1.002271144
Kurtosis	37.63950264
Mean	57.03379823
Median Absolute Deviation (MAD)	14.30000115
Skewness	4.827517733
Sum	192203.9
Variance	3267.646321
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	29	0.9%
29.5	17	0.5%
30.79999924	15	0.4%
27.89999962	14	0.4%
30.20000076	14	0.4%
31.60000038	14	0.4%
29	14	0.4%
32.20000076	14	0.4%
33.59999847	13	0.4%
31.39999962	13	0.4%
Other values (1095)	3213	95.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	29	0.9%
0.400000006	1	< 0.1%
0.699999988	1	< 0.1%
1	1	< 0.1%
1.5	1	< 0.1%

Value	Count	Frequency (%)
834.4000244	1	< 0.1%
707.2999878	1	< 0.1%
694.7000122	1	< 0.1%
693.0999756	1	< 0.1%
639.7999878	1	< 0.1%

SourceEUI(kBtu/sf)
Real number (ℝ)

Distinct	1648
Distinct (%)	48.9%
Missing	9
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	134.2328482

Minimum	0
Maximum	2620
Zeros	24
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	37.85999947
Q1	74.69999695
median	96.19999695
Q3	143.8999939
95-th percentile	351.6700104
Maximum	2620
Range	2620
Interquartile range (IQR)	69.19999695

Descriptive statistics

Standard deviation	139.2875538
Coefficient of variation (CV)	1.037656249
Kurtosis	77.66477838
Mean	134.2328482
Median Absolute Deviation (MAD)	27.79999542
Skewness	6.595043734
Sum	451962
Variance	19401.02264
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	24	0.7%
83.69999695	9	0.3%
68.09999847	9	0.3%
90.5	8	0.2%
73.09999847	8	0.2%
78.59999847	8	0.2%
87.69999695	8	0.2%
94.09999847	8	0.2%
95	8	0.2%
69.69999695	8	0.2%
Other values (1638)	3269	96.8%
(Missing)	9	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	24	0.7%
1.100000024	1	< 0.1%
2	1	< 0.1%
2.099999905	1	< 0.1%
3	1	< 0.1%

Value	Count	Frequency (%)
2620	1	< 0.1%
2217.800049	1	< 0.1%
2181.300049	1	< 0.1%
2007.900024	1	< 0.1%
1527.300049	1	< 0.1%

SourceEUIWN(kBtu/sf)
Real number (ℝ)

ZEROS

Distinct	1694
Distinct (%)	50.3%
Missing	9
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	137.7839323

Minimum	-2.099999905
Maximum	2620
Zeros	36
Zeros (%)	1.1%
Negative	1
Negative (%)	< 0.1%
Memory size	26.5 KiB

Quantile statistics

Minimum	-2.099999905
5-th percentile	37.70000076
Q1	78.40000153
median	101.0999985
Q3	148.3499985
95-th percentile	353.8600037
Maximum	2620
Range	2622.1
Interquartile range (IQR)	69.94999697

Descriptive statistics

Standard deviation	139.1098067
Coefficient of variation (CV)	1.009622852
Kurtosis	77.44186155
Mean	137.7839323
Median Absolute Deviation (MAD)	28.50000003
Skewness	6.569688358
Sum	463918.5
Variance	19351.53831
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	36	1.1%
73.59999847	9	0.3%
87.30000305	9	0.3%
93.59999847	8	0.2%
75.5	8	0.2%
102.4000015	8	0.2%
98.90000153	8	0.2%
83.5	8	0.2%
84.90000153	8	0.2%
104.5999985	8	0.2%
Other values (1684)	3257	96.5%
(Missing)	9	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2.099999905	1	< 0.1%
0	36	1.1%
1.100000024	1	< 0.1%
2.200000048	1	< 0.1%
3	1	< 0.1%

Value	Count	Frequency (%)
2620	1	< 0.1%
2217.800049	1	< 0.1%
2181.300049	1	< 0.1%
2008	1	< 0.1%
1527.300049	1	< 0.1%

SiteEnergyUse(kBtu)
Real number (ℝ)

SKEWED

Distinct	3354
Distinct (%)	99.5%
Missing	5
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	5403667.295

Minimum	0
Maximum	873923712
Zeros	18
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	491819.9531
Q1	925128.5938
median	1803753.25
Q3	4222455.25
95-th percentile	18161625
Maximum	873923712
Range	873923712
Interquartile range (IQR)	3297326.656

Descriptive statistics

Standard deviation	21610628.63
Coefficient of variation (CV)	3.999252258
Kurtosis	858.6184814
Mean	5403667.295
Median Absolute Deviation (MAD)	1074356.062
Skewness	24.84197927
Sum	1.821576245 × 10¹⁰
Variance	4.670192697 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	18	0.5%
586358.875	1	< 0.1%
12213423	1	< 0.1%
6714540	1	< 0.1%
4653535	1	< 0.1%
8163413	1	< 0.1%
415364.5938	1	< 0.1%
561473.875	1	< 0.1%
905750.375	1	< 0.1%
2253647.75	1	< 0.1%
Other values (3344)	3344	99.1%
(Missing)	5	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	18	0.5%
13409	1	< 0.1%
16808.90039	1	< 0.1%
24105.5	1	< 0.1%
44293.5	1	< 0.1%

Value	Count	Frequency (%)
873923712	1	< 0.1%
448385312	1	< 0.1%
293090784	1	< 0.1%
291614432	1	< 0.1%
274682208	1	< 0.1%

SiteEnergyUseWN(kBtu)
Real number (ℝ)

Distinct	3341
Distinct (%)	99.1%
Missing	6
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	5276725.714

Minimum	0
Maximum	471613856
Zeros	29
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	503320.811
Q1	970182.2344
median	1904452
Q3	4381429.125
95-th percentile	18203297.4
Maximum	471613856
Range	471613856
Interquartile range (IQR)	3411246.891

Descriptive statistics

Standard deviation	15938786.48
Coefficient of variation (CV)	3.020582715
Kurtosis	334.5050175
Mean	5276725.714
Median Absolute Deviation (MAD)	1130097.25
Skewness	15.26906663
Sum	1.778256566 × 10¹⁰
Variance	2.540449146 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	29	0.9%
2127889.25	2	0.1%
963968.1875	1	< 0.1%
150167.7969	1	< 0.1%
1386445.375	1	< 0.1%
1519845.5	1	< 0.1%
455648.9063	1	< 0.1%
13089102	1	< 0.1%
6739209	1	< 0.1%
4653535	1	< 0.1%
Other values (3331)	3331	98.7%
(Missing)	6	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	29	0.9%
13409	1	< 0.1%
17260	1	< 0.1%
24105.5	1	< 0.1%
44293.5	1	< 0.1%

Value	Count	Frequency (%)
471613856	1	< 0.1%
296671744	1	< 0.1%
295929888	1	< 0.1%
274725984	1	< 0.1%
257764208	1	< 0.1%

SteamUse(kBtu)
Real number (ℝ)

SKEWED ZEROS

Distinct	131
Distinct (%)	3.9%
Missing	9
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	274595.8982

Minimum	0
Maximum	134943456
Zeros	3237
Zeros (%)	95.9%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	134943456
Range	134943456
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3912173.393
Coefficient of variation (CV)	14.24702051
Kurtosis	804.8642147
Mean	274595.8982
Median Absolute Deviation (MAD)	0
Skewness	26.72088824
Sum	924564389.3
Variance	1.530510065 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3237	95.9%
12508892	1	< 0.1%
882630.6875	1	< 0.1%
3578548.25	1	< 0.1%
1158118.25	1	< 0.1%
1165335.75	1	< 0.1%
2796766	1	< 0.1%
2003882	1	< 0.1%
1472483.375	1	< 0.1%
230989.2969	1	< 0.1%
Other values (121)	121	3.6%
(Missing)	9	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3237	95.9%
21230.80078	1	< 0.1%
137900	1	< 0.1%
151742.5	1	< 0.1%
166488.4063	1	< 0.1%

Value	Count	Frequency (%)
134943456	1	< 0.1%
122575032	1	< 0.1%
84985240	1	< 0.1%
73885472	1	< 0.1%
31030194	1	< 0.1%

Electricity(kWh)
Real number (ℝ)

SKEWED

Distinct	3352
Distinct (%)	99.6%
Missing	9
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	1086638.967

Minimum	-33826.80078
Maximum	192577488
Zeros	14
Zeros (%)	0.4%
Negative	1
Negative (%)	< 0.1%
Memory size	26.5 KiB

Quantile statistics

Minimum	-33826.80078
5-th percentile	72675.63985
Q1	187422.9453
median	345129.9063
Q3	829317.8438
95-th percentile	3944193.125
Maximum	192577488
Range	192611314.8
Interquartile range (IQR)	641894.8984

Descriptive statistics

Standard deviation	4352478.355
Coefficient of variation (CV)	4.005450282
Kurtosis	1157.498858
Mean	1086638.967
Median Absolute Deviation (MAD)	200696.3125
Skewness	28.72846386
Sum	3658713400
Variance	1.894406783 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	14	0.4%
239011.5938	2	0.1%
317841.4063	2	0.1%
1156514.25	1	< 0.1%
154136.4063	1	< 0.1%
406343.8125	1	< 0.1%
165367.7031	1	< 0.1%
123502.2031	1	< 0.1%
1437784.625	1	< 0.1%
592280.875	1	< 0.1%
Other values (3342)	3342	99.0%
(Missing)	9	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-33826.80078	1	< 0.1%
0	14	0.4%
1	1	< 0.1%
1798.900024	1	< 0.1%
3332.5	1	< 0.1%

Value	Count	Frequency (%)
192577488	1	< 0.1%
80460872	1	< 0.1%
49438336	1	< 0.1%
44102076	1	< 0.1%
40842564	1	< 0.1%

Electricity(kBtu)
Real number (ℝ)

SKEWED

Distinct	3351
Distinct (%)	99.5%
Missing	9
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	3707612.162

Minimum	-115417
Maximum	657074389
Zeros	14
Zeros (%)	0.4%
Negative	1
Negative (%)	< 0.1%
Memory size	26.5 KiB

Quantile statistics

Minimum	-115417
5-th percentile	247969.2
Q1	639487
median	1177583
Q3	2829632.5
95-th percentile	13457586.8
Maximum	657074389
Range	657189806
Interquartile range (IQR)	2190145.5

Descriptive statistics

Standard deviation	14850656.14
Coefficient of variation (CV)	4.005450271
Kurtosis	1157.498861
Mean	3707612.162
Median Absolute Deviation (MAD)	684776
Skewness	28.72846389
Sum	1.248353015 × 10¹⁰
Variance	2.205419878 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	14	0.4%
815508	2	0.1%
804194	2	0.1%
1084475	2	0.1%
3946027	1	< 0.1%
166749	1	< 0.1%
138179	1	< 0.1%
1386445	1	< 0.1%
564235	1	< 0.1%
421390	1	< 0.1%
Other values (3341)	3341	99.0%
(Missing)	9	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-115417	1	< 0.1%
0	14	0.4%
3	1	< 0.1%
6138	1	< 0.1%
11370	1	< 0.1%

Value	Count	Frequency (%)
657074389	1	< 0.1%
274532495	1	< 0.1%
168683602	1	< 0.1%
150476283	1	< 0.1%
139354828	1	< 0.1%

NaturalGas(therms)
Real number (ℝ)

SKEWED ZEROS

Distinct	2109
Distinct (%)	62.6%
Missing	9
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	13685.04538

Minimum	0
Maximum	2979090
Zeros	1258
Zeros (%)	37.3%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3237.537598
Q3	11890.33496
95-th percentile	49023.72422
Maximum	2979090
Range	2979090
Interquartile range (IQR)	11890.33496

Descriptive statistics

Standard deviation	67097.8083
Coefficient of variation (CV)	4.903002252
Kurtosis	1201.032447
Mean	13685.04538
Median Absolute Deviation (MAD)	3237.537598
Skewness	30.03889031
Sum	46077547.78
Variance	4502115878
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1258	37.3%
2268.460205	2	0.1%
12764.5293	1	< 0.1%
2486.159912	1	< 0.1%
119.8899918	1	< 0.1%
7672.350098	1	< 0.1%
73077.01563	1	< 0.1%
46936.77344	1	< 0.1%
52450.41797	1	< 0.1%
4248.649902	1	< 0.1%
Other values (2099)	2099	62.2%
(Missing)	9	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1258	37.3%
0.329999954	1	< 0.1%
1.530000091	1	< 0.1%
2.199999809	1	< 0.1%
3.320000172	1	< 0.1%

Value	Count	Frequency (%)
2979090	1	< 0.1%
1381912.375	1	< 0.1%
846680.9375	1	< 0.1%
679905.375	1	< 0.1%
667464.25	1	< 0.1%

NaturalGas(kBtu)
Real number (ℝ)

SKEWED ZEROS

Distinct	2109
Distinct (%)	62.6%
Missing	9
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	1368504.541

Minimum	0
Maximum	297909000
Zeros	1258
Zeros (%)	37.3%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	323754
Q3	1189033.5
95-th percentile	4902372.3
Maximum	297909000
Range	297909000
Interquartile range (IQR)	1189033.5

Descriptive statistics

Standard deviation	6709780.835
Coefficient of variation (CV)	4.903002242
Kurtosis	1201.032444
Mean	1368504.541
Median Absolute Deviation (MAD)	323754
Skewness	30.03889028
Sum	4607754791
Variance	4.502115885 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1258	37.3%
226846	2	0.1%
1276453	1	< 0.1%
248616	1	< 0.1%
11989	1	< 0.1%
767235	1	< 0.1%
7307702	1	< 0.1%
4693677	1	< 0.1%
5245042	1	< 0.1%
424865	1	< 0.1%
Other values (2099)	2099	62.2%
(Missing)	9	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1258	37.3%
33	1	< 0.1%
153	1	< 0.1%
220	1	< 0.1%
332	1	< 0.1%

Value	Count	Frequency (%)
297909000	1	< 0.1%
138191238	1	< 0.1%
84668094	1	< 0.1%
67990538	1	< 0.1%
66746425	1	< 0.1%

DefaultData
Boolean

IMBALANCE

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.4 KiB

False	3263
True	113

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	3263	96.7%
True	113	3.3%

Comments
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	3376
Missing (%)	100.0%
Memory size	26.5 KiB

ComplianceStatus
Text

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.5 KiB

Length

Max length	28
Median length	9
Mean length	9.693127962
Min length	9

Characters and Unicode

Total characters	32724
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Compliant
2nd row	Compliant
3rd row	Compliant
4th row	Compliant
5th row	Compliant

Value	Count	Frequency (%)
compliant	3211	83.6%
data	128	3.3%
error	113	2.9%
	113	2.9%
correct	113	2.9%
default	113	2.9%
non-compliant	37	1.0%
missing	15	0.4%

Most occurring characters

Value	Count	Frequency (%)
a	3617	11.1%
t	3602	11.0%
o	3511	10.7%
C	3361	10.3%
l	3361	10.3%
n	3300	10.1%
i	3278	10.0%
m	3248	9.9%
p	3248	9.9%
r	565	1.7%
Other values (12)	1633	5.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	32724	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	3617	11.1%
t	3602	11.0%
o	3511	10.7%
C	3361	10.3%
l	3361	10.3%
n	3300	10.1%
i	3278	10.0%
m	3248	9.9%
p	3248	9.9%
r	565	1.7%
Other values (12)	1633	5.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	32724	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	3617	11.1%
t	3602	11.0%
o	3511	10.7%
C	3361	10.3%
l	3361	10.3%
n	3300	10.1%
i	3278	10.0%
m	3248	9.9%
p	3248	9.9%
r	565	1.7%
Other values (12)	1633	5.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	32724	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	3617	11.1%
t	3602	11.0%
o	3511	10.7%
C	3361	10.3%
l	3361	10.3%
n	3300	10.1%
i	3278	10.0%
m	3248	9.9%
p	3248	9.9%
r	565	1.7%
Other values (12)	1633	5.0%

Outlier
Text

MISSING

Distinct	2
Distinct (%)	6.2%
Missing	3344
Missing (%)	99.1%
Memory size	26.5 KiB

Length

Max length	12
Median length	11
Mean length	11.28125
Min length	11

Characters and Unicode

Total characters	361
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	High outlier
2nd row	Low outlier
3rd row	Low outlier
4th row	High outlier
5th row	Low outlier

Value	Count	Frequency (%)
outlier	32	50.0%
low	23	35.9%
high	9	14.1%

Most occurring characters

Value	Count	Frequency (%)
o	55	15.2%
i	41	11.4%
	32	8.9%
u	32	8.9%
t	32	8.9%
l	32	8.9%
e	32	8.9%
r	32	8.9%
L	23	6.4%
w	23	6.4%
Other values (3)	27	7.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	361	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	55	15.2%
i	41	11.4%
	32	8.9%
u	32	8.9%
t	32	8.9%
l	32	8.9%
e	32	8.9%
r	32	8.9%
L	23	6.4%
w	23	6.4%
Other values (3)	27	7.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	361	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	55	15.2%
i	41	11.4%
	32	8.9%
u	32	8.9%
t	32	8.9%
l	32	8.9%
e	32	8.9%
r	32	8.9%
L	23	6.4%
w	23	6.4%
Other values (3)	27	7.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	361	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	55	15.2%
i	41	11.4%
	32	8.9%
u	32	8.9%
t	32	8.9%
l	32	8.9%
e	32	8.9%
r	32	8.9%
L	23	6.4%
w	23	6.4%
Other values (3)	27	7.5%

TotalGHGEmissions
Real number (ℝ)

Distinct	2818
Distinct (%)	83.7%
Missing	9
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	119.7239709

Minimum	-0.8
Maximum	16870.98
Zeros	9
Zeros (%)	0.3%
Negative	1
Negative (%)	< 0.1%
Memory size	26.5 KiB

Quantile statistics

Minimum	-0.8
5-th percentile	3.78
Q1	9.495
median	33.92
Q3	93.94
95-th percentile	392.797
Maximum	16870.98
Range	16871.78
Interquartile range (IQR)	84.445

Descriptive statistics

Standard deviation	538.8322265
Coefficient of variation (CV)	4.500621074
Kurtosis	474.8922233
Mean	119.7239709
Median Absolute Deviation (MAD)	27.94
Skewness	19.48187492
Sum	403110.61
Variance	290340.1683
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9	0.3%
3.95	7	0.2%
4.2	6	0.2%
5.46	6	0.2%
4.74	5	0.1%
5.07	5	0.1%
6.18	5	0.1%
3.63	5	0.1%
4.8	5	0.1%
4.02	5	0.1%
Other values (2808)	3309	98.0%
(Missing)	9	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.8	1	< 0.1%
0	9	0.3%
0.09	1	< 0.1%
0.12	1	< 0.1%
0.17	1	< 0.1%

Value	Count	Frequency (%)
16870.98	1	< 0.1%
12307.16	1	< 0.1%
11140.56	1	< 0.1%
10734.57	1	< 0.1%
8145.52	1	< 0.1%

GHGEmissionsIntensity
Real number (ℝ)

Distinct	511
Distinct (%)	15.2%
Missing	9
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	1.175916246

Minimum	-0.02
Maximum	34.09
Zeros	12
Zeros (%)	0.4%
Negative	1
Negative (%)	< 0.1%
Memory size	26.5 KiB

Quantile statistics

Minimum	-0.02
5-th percentile	0.13
Q1	0.21
median	0.61
Q3	1.37
95-th percentile	3.961
Maximum	34.09
Range	34.11
Interquartile range (IQR)	1.16

Descriptive statistics

Standard deviation	1.821451788
Coefficient of variation (CV)	1.548963878
Kurtosis	57.37215629
Mean	1.175916246
Median Absolute Deviation (MAD)	0.44
Skewness	5.593144823
Sum	3959.31
Variance	3.317686616
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.17	99	2.9%
0.15	99	2.9%
0.16	96	2.8%
0.18	86	2.5%
0.19	78	2.3%
0.2	70	2.1%
0.13	66	2.0%
0.14	62	1.8%
0.21	60	1.8%
0.22	54	1.6%
Other values (501)	2597	76.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.02	1	< 0.1%
0	12	0.4%
0.01	4	0.1%
0.02	4	0.1%
0.03	7	0.2%

Value	Count	Frequency (%)
34.09	1	< 0.1%
25.71	1	< 0.1%
16.99	1	< 0.1%
16.93	1	< 0.1%
16.91	1	< 0.1%

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks